I'm working on a new database and I don't have much expirience.
I've already made the tables and their relationships.
What I need?
I need to make the forms for this tables, but I'd like this kind of situation:
I have a "proposals" table and "adjudication" table both of them are related with wich other by field "proposalID" and this two tables are related with another table "Clients".
I need to make very proposals and when they are adjudicated i'll go to the proposals form find the correct proposal and click on a botton that is going to open the adjudication form that should already have the information I need (the correct proposal and client information) in order to process the request.