hello there! i want to create a webbased database.so i have a table with customer data,(cust_id is primary key) and many other tables and i quess is better to put a foreign key to other tables to store cust_id.how can i fill the foreign key (eg purchase table.cust_id) with the value of cust_id automatically ? i think to create a hidden field in the form and autofill it with ajax... can this be done or i should try another way ? thn in advanced!