How can 1 form field set a value in many related tables?

B

BP522

I have a database with school information. Table are school information,
teacher information, billing information ... Each of these fields is related
by the school name. I havea query to enter all the information of a new
school and want to enter in a form. How can I set 1 field that will set the
value of school name in all tables?

Thank you
 
Top