I have a relational database, table A is connected to table B through table A's primary key. Table B is then connected to Table C through its own primary key.
So in other words, in order for me to enter data for a topic/record I must first enter the data into A before putting it into B and then C through the linked keys.
For example, a Customers Table (A) linked with a Orders Table (B) through a primary customer ID key and the specific Orders are then linked with subsequent "Purchases" (C)
Any advice? Currently I have three separate forms but I'm not sure what the best way is to combine them into a concise form.