Blasphemer
11-17-2008, 09:19 AM
Hi,
I am building a database which will records 100 details for a single customer in 5 different tables. They will be all recognized by an account number (Autonumber primarykey). Now when my teller starts to enter the data he has to fill 5 forms for a single customer.
What I would like to know is what is the best practice to follow for information to flow between forums.
Note: I want to enter details in tables only if the teller is successfully able to fill up all 5 forums. If he cancels in between the database should not be affected. To implement this I would need the information filled in 1 form to stay in memory till the last form is filled.
What are the best practices to follow in this case.
I could use global variables and put everything in them but I honestly do not want to make 100 variables as there are 100 fields in about 5 tables.
Thoughts?
Regards
I am building a database which will records 100 details for a single customer in 5 different tables. They will be all recognized by an account number (Autonumber primarykey). Now when my teller starts to enter the data he has to fill 5 forms for a single customer.
What I would like to know is what is the best practice to follow for information to flow between forums.
Note: I want to enter details in tables only if the teller is successfully able to fill up all 5 forums. If he cancels in between the database should not be affected. To implement this I would need the information filled in 1 form to stay in memory till the last form is filled.
What are the best practices to follow in this case.
I could use global variables and put everything in them but I honestly do not want to make 100 variables as there are 100 fields in about 5 tables.
Thoughts?
Regards