June7
AWF VIP
- Local time
- Yesterday, 22:42
- Joined
- Mar 9, 2014
- Messages
- 5,463
An UPDATE in plugstamp function is producing mismatch error because [entryid_hist] is set as a text field and the IN list is passing number values. Relationship builder allowed a link to be established with numeric PK but since fields are different data type, will fail in queries. You will have to remove Relationship link, change field type, reset Relationship.
This same query is setting Notes to empty string because [nots] is null (don't know why). I NEVER allow empty strings in tables. I would set to Null if no value provided.
tbl_PBinfo and tbl_PBreso link on primary key fields which is a 1-to-1 relationship. Why not just have 1 table?
This same query is setting Notes to empty string because [nots] is null (don't know why). I NEVER allow empty strings in tables. I would set to Null if no value provided.
tbl_PBinfo and tbl_PBreso link on primary key fields which is a 1-to-1 relationship. Why not just have 1 table?
Last edited: