I have a select query that I concatenated two fields from two different tables, neither of the fields are PKs.
tblJobsItemDetails and tblJobItemDetailsAcc into one field so my list is like this: 10-1, 10-2, 11-1, 11-2, 11-3, 12-1, 13-1, 13-2, ect.
This gets me the list of accessories in a format that my users can understand.
Now I will make a select query from the tblJobsItemDetails with the item list for the main items like this: 10,11,12,13 ect or should I cantaenate a "0" to them to have similar data structure? 10-0, 11-0, 12-0, ect.
Then I will make a UNION query to hold each item whether it be the main item, or an accessory for a particular item, in order to bind the recordset to a "Time Clock" form for employees to "punch" in/out of items in the combined list for time tracking in manufacturing.
My question is this - will the data easily be extracted back out from the fields back to their original data fields for time tracking of the individual items - whether they be a main item or an item's accessory?
Thanks as this is my first attempt to use much concatenation, much less UNION queries.
tblJobsItemDetails and tblJobItemDetailsAcc into one field so my list is like this: 10-1, 10-2, 11-1, 11-2, 11-3, 12-1, 13-1, 13-2, ect.
This gets me the list of accessories in a format that my users can understand.
Now I will make a select query from the tblJobsItemDetails with the item list for the main items like this: 10,11,12,13 ect or should I cantaenate a "0" to them to have similar data structure? 10-0, 11-0, 12-0, ect.
Then I will make a UNION query to hold each item whether it be the main item, or an accessory for a particular item, in order to bind the recordset to a "Time Clock" form for employees to "punch" in/out of items in the combined list for time tracking in manufacturing.
My question is this - will the data easily be extracted back out from the fields back to their original data fields for time tracking of the individual items - whether they be a main item or an item's accessory?
Thanks as this is my first attempt to use much concatenation, much less UNION queries.