Newbie Question about multiple transactions

[biggierob]

I have created two table, one for customer information and one for the check information. I wanto to know how to configure the check table to be able to add multiple transactions. for example if a previous customer comes in I call up there account via there customer number(ssn) and add the next check information to the record. Any help would be appreciated

 

[rockman]

In your check table have a field for the customer ID.

Easiest way to implement this is the make a form based on you customer table then add a subform that is based on your check table. Assign the parent/child based on the customer ID number in each table and voila!

Hope this helps,
Jeff

 

[biggierob]

ok so i have the customer number as the primary key in both of my tables. Will that prevent me from adding records for the same custoimer number in the check table? i.e. if a customers number is 0011 and i go into the table and click the plus next to the customer number and just add the next transaction information?

 

[rockman]

CustID is primary in customer table
CheckID is primary in check table

Set CustID relationship one-to-many between customer and check table

And yes, if you just want to use the table to enter data, click the (+) sign and enter in your checks.

Jeff