Linking tables with forms

[Belgarion]

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

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.

 

[Damon Heron]

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