[thelist] Relational DB

[Faye Tarzwell(FayeC)]

Hi,

Sorry for the somewhat silly question.
I have a 4 tables with simple relationships among them (table 1 has 1
field from table 2, one field from table 3 and table 3 has one field
from table 4).
The problem I am having is finding out how to write to all tables at once.
For example:
I need to create a form that will have fields from all 4 tables and on
submit it will write to all 4 tables.
I know how to write to one table at a time but got a little confused
with the explanation on how to write to more than one table at a
time...specially if a table has fields from the other tables...
Could anybody give me a hint?
I have looked on books and did a google search but didn't really find
anything useful.

Thanks,

FayeC