Newbie table relationship question

[grx21]

I have two related tables, the relationship is one-to-many.

Tbl.distributor: distributor_id, distributor_name, city, phone, email_address

Tbl.order: order_id, distributor_id, order_date, ship_method, ship_date, po_number

What I don’t understand is the following: After the distributor information has been inserted into the tbl.distributor how does the distributor_id end up in the order table as well?

--grx21

 

[tlbroadbent]

See reply in thread701-213260.

Please avoid cross-posting. This is actually a better forum for your question than the other forum but I saw that post first and replied there.

Thanks, Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com