Simple Simple Question..

  • Thread starter Thread starter seth.northrop
  • Start date Start date
S

seth.northrop

Hi,

Can someone point me to a website or resource that covers creation of
forms from multiple tables? I'm new to access but have a decent
background in DB design.

Given three tables: A, B, and C where C just contains the PKs of A and
B I want to create a form that populates table C. The form would
contain pull downs with non key elements from A and B (ie, let's say
names). When the user selects the names in the pull down, the form
would populate the table with the ID's associated with those names.

This seems completely basic - but, I can't figure out how to do this
from the help pages.

Help!
 
Given three tables: A, B, and C where C just contains the PKs of A and
B I want to create a form that populates table C. The form would
contain pull downs with non key elements from A and B (ie, let's say
names). When the user selects the names in the pull down, the form
would populate the table with the ID's associated with those names.
Click to expand...

By populate, you mean display that information? Right, I mean, we have a
relational database (you obviously know what that is) here.

The whole art, or whole concept behind a relational database is that you
don't have to "copy" the information.

So, here is what you can do

Create a form. You can base the datasouce of this form on table c.

Now, use the combo box wizard to allow you to select record from table a.
The combo box can have several columns of data from table a, but the 1st
column of the combo box will of course be the pk value of the table a.

Now, to *display* all of the data (as many fields as you need) from table
a, you simply dorop in a sub-form. this whole approach thus will NOT TAKE
ONE LINE OF CODE!!

you can also do the example same thing for the 2nd field (that is a pk to
table b). Again, just build a combo box (use the wizard). And, again, just
drop in a subform based on table b.

I talk about using a sub-form to display related table data here:

http://www.members.shaw.ca/AlbertKallal/Articles/fog0000000005.html
 
By "populate" I mean add data to. Ie, the result of the form would be
that an entry would be dropped into table C that contains aID and bID
based on the user selecting aName and bName from pull downs or some
other data entry mechanism.

I think, despite our different definitions, your recommendations are
still applicable.

Let me give it a try.

Thanks.
 
Back
Top