Creating a form based on four tables

A

aweise

I have four tables. One table is called directory it holds the primar
keys to the other three tables (Provider_id, District_id, Rep_id).
build new information in each of the three tables when required an
then my main query is based on what is in the directory table. I woul
like to set up a form as follows: Add Provider, Add Reps, Ad
Districts, Update Directory. You would update the directory once an
new information had been added. How would I go about coding this form
Ideally the the primary field from whatever table I update should b
added to the Directory so that it would show up on the Providers Repor
I run.

Thanks for your help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I clear a form? 0
Data entry for a table from a form 1
Copy previous record into form field 0
Adding timestamp code to form with a subform. 1
Copy form datasheet to table 4
Form needs to update two tables then ... 5
Create new record in diff table 1
Filter main form to records with no related records in subform,maintain updateable recordset 4

Top