Software

Ask something
Discussion Locked

Appending data to a table from a form

0 helpful
1 reply

by comphelpnj 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Using Access 2000, I'd like to use a form that will query one table to populate part of the form, then have the user enter data in the remainging fields in the form, and then post that user data to the end of a different table. I figured out how to query a table to populate part of the form, but I can't figure out the second half - appending the data to a different table from that same form. Any suggestions?

I am trying to create a shipping screen that will populate the form with the customer's shipping data (name, address, shipping method, etc) from one table, then allow the user to enter addtional shipping data (carrier, service, weight, tracking number, etc), then post that data to another table containing the daily shipping records.

I'm sure this can be done with some type of macro activated within the form, but not being that fluent in Access forms or macros I just can't figure this one out.

Thanks for your help.

1 reply

by ozi eagle

Hi,

Part of the beauty of relational databases, like access, is that you don't need to duplicate data, you just record a relationship to it.

In your case there is no need to store the customer data in another table, just a reference to the customer id.

Then, when you wish to print reports etc., you create a query that accesses the two (or more)tables that contain, respectively, the customer data and then their shipping data.

This way you have a table that contains the customer data eg Joe Blogg address etc, taking up one record, and maybe with id "1". The other table would be your shipping table that would have many entries for Joe Blogg (assuming he is a frequent customer), but you would not be repeating Joe Blogg, address etc with every shipment, you would just have a reference in the table as Customer id = 1 and this would link back to the customer table, giving you all Joe's details.

This discussion is closed to new replies.