hackenhead
Technical User
Good Morning .. I have a couple of questions related to Destination Tables:
Autonumbering - I have 2 source tables for data that feed two separate forms (the data has no primary key to tie the tables together - they consist of client data and product data).
I've created a destination table for the compiled data, which is where I would like the autonumbering to occur (enabling me to pull reports from the data). Is this possible?
Also, how do I go about saving the compiled data to the destination table? I understand Access saves the data automatically .. but not to this table. I've tried queries and macros with no luck.
Thank you in advance,
Access Novice
________________________________________
"Persistence is your desire to succeed combined with your creative presence." .. Jeffrey Gitomer
Autonumbering - I have 2 source tables for data that feed two separate forms (the data has no primary key to tie the tables together - they consist of client data and product data).
I've created a destination table for the compiled data, which is where I would like the autonumbering to occur (enabling me to pull reports from the data). Is this possible?
Also, how do I go about saving the compiled data to the destination table? I understand Access saves the data automatically .. but not to this table. I've tried queries and macros with no luck.
Thank you in advance,
Access Novice
________________________________________
"Persistence is your desire to succeed combined with your creative presence." .. Jeffrey Gitomer
