By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,154 Members | 1,024 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,154 IT Pros & Developers. It's quick & easy.

Need help with form pulling from multiple tables appending to another table

P: 3
Hi all! What a great community you have here. Being an Access newbie I have already used much information gleaned from the other posters for my current project.

I have been tasked with creating a database that will link to a table ("tbl_Data File) located in another database ("Database1"). Changes will be made to a customer record queried from Database1 and saved in a table located in Database2 called "tbl_Instructions".

So far I have created a database ("Database2") and the table that links with the other database along with a form that pulls the necessary fields from the linked database by a query. I will also be creating multiple tables that will feed listboxes on the same form as well as textboxes where the user can enter free form text. The problem I'm having is that I want the user to be able to enter data for a specific customer record on the form, making changes to the linked data and enter information from the listboxes and textboxes. Lastly, I want to append only that record to a table in Database2 by clicking on a command button on the form.

I know that this design goes against database design principles, however there are currently data integrity issues within Database1. What we want to accomplish is to capture historical information for reference in Database2 that is accurate based on what was processed. A letter is sent to customers based on the processing within the Database2 and the information could be needed at a later date. In reality, the data contained within Database2 will be a transaction list or the customer so we want multiple entries for each customer.

Any help would be greatly appreciated!
Nov 29 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.