Linking tables with forms

  • Thread starter Thread starter Belgarion
  • Start date Start date
B

Belgarion

Hi, I'm still a relative beginner with Access, but I've not done too
bad :P

However, I'm finding one thing very confusing.

Here's the scenario: I am writing a multi table db, and I need to link
them all up via an index, so one form can easily display data from the
others.

For example: I need to display a name, located from one table, and
then in a seperate table, store values from yet other tables.

For some reason, I am finding this a little bit of a pain to do - I
can't seem to get the values loaded correctly. It's no problem if
they are simply from a table, but the problem I have is when I need to
show a combo list of values DEPENDING on the value of one of the other
combo's on the same form. That combo would pull data from other
tables, and store them in the new table.

I am pretty sure this is rudimentary - I just can't see where I'm
going wrong. I don't expect a long tutorial on how to do this, but
could someone point me in the right direction?

Ta.
 
A simple answer is to make the rowsource of your second combobox select
items based on the result of the first combobox
Here is an example- modify to your naming structure:

SELECT Yourtbl.ID, Yourtbl.Name, Yourtbl.LocID, Yourtbl.Notes FROM Yourtbl
WHERE (((Yourtbl.ID)=[Yourfirstcbo].[value]))
ORDER BY Yourtbl.Name;

Damon
 
Back
Top