asked on

data entry form in access

I have 2 tables, 'contact list' & 'transactions', and every few months people in the contact list pay their fees. What I would like to do is have a form that shows everyone in the contact list with blank fields from the transaction table so that I can enter transactions for the ones that have paid. My tables are structured as detailed below.

Contact List - pID, First Name, Last Name

Transactions - ID, pID, Date Paid, SessionNo, ChequeNo, Amount

I attach a stripped down version of my DB.

Andy
Stripped-down.accdb

Scott McDaniel (EE MVE )

I downloaded your database, and don't see the form you're referring to. While we don't mind helping you achieve your goals, we aren't here to do the work for you. Instead, we'll help you when you run into something you can't solve yourself.

I would assume you could create a Mainform/Subform sort of setup to achieve what you want. First, create two forms - one based on the ContactList table, and another based on the Transactions table. Embed the Transaction form into the ContactList form, and link them on the pID field. From there you could locate a Contact using the navigation buttons, and enter a Transaction in the Subform. If you setup the linking correct between the Mainform and Subform, Access will handle the data relationships for you, and insert the records in the correct table.

Rey Obrero (Capricorn1)

create a Form/subform combination for your data entry
see this Create Form with subform

Andrew

ASKER

Thank you Scott/Rey

Yes, I understand your comments and I certainly do not expect you to do my work. I should have explained that I already have a form/subform scenario, but I was wondering if it would be possible to have a situation where the existing contacts all show on the same form with blank columns for the transactions. See my basic concept attached.

Andy
Book1.xlsx

SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Andrew

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Andrew

ASKER

Scott's comments made me think about other options, so have thought about another way of achieving my goal.