Form uses 1 table but txt box to another table

[Chessico]

I have a form 'frmMembers' which takes data entry and stores it in tblMembers. The form already has 2 tabs - 1 for main member the other for their dependants. The tab for the main member also contains a sub form of payments linked to take payment details which are stored in tblPayments.
I have a drop down box to choose from Membership types stored in tblCategory. All work fine
The membership (for a Rugby club) have now introduced a Loyalty Card scheme. At present I don't know how much different data needs storing in the tblLoyaltyCard. It may need more than 1 card per family i.e more than 1 number. To save having to redesign it later I want to set it up as a separate table to store a card number assigned by the EPOS till system. So tblLoyaltyCard has key field autonumber, Foreign Key MembId from tblMembers, LCardNo Number - to be entered from the membership entry form. This creates the problem -I want to enter data into the form but because its source is tblMembers I cannot get it to link and send data to store into another table - tblLoyaltyCard. Is it possible

 

[boblarson]

Use a subform for that other table.

 

[Chessico]

Yes - I thought that would be the answer but I am getting low on space on the form and don't want a pop up form. I will do this but just wondered if it could be done directly into the main form via a query ? Basically I've searched forums but no one seems able to solve this and its mainly become a task to see if it is possible to do this or not. Many thanks anyway.