hey.

i have 3 tables with relationships: proposals (PK=number),
versions (PK=number+version_num) and data
(PK=number+version_num+option-num).
i have also 3 queries and forms based on these queries.
i want that when the user is in form_proposal and click
on "add_new_proposal", he will get a number for the new
proposal and also this new proposal he entered will have
first (empty)version and firs (empty) option. so the user
can click on "enter_proposal" and type in the proposal
details.
i hope my question is clear. i need records to be
added "automatically" wuth on-click event in a different
form.
thanks