OK. So I can only ask one question.....I hope I get this right.....
I took an access class 2 years ago and never touched it again. I was recently asked to create a database and I actually remembered a little more than I thought. I am creating a PRC database, basically keeping track of clients and services that we provide for the different divisions and the fiscal staff.
My Customer table fields are: CustomerID (auto#), SSN (no dubs), FN, LN, Address, Phone, Case#, Max Eligibility
My Vouchers table fields are: CustomerID (#), Voucher# (auto#), Date Issued, Appt Date, AmountAuthorized, Department, Case Manager, PRCcode, PRCservice, AddlInfo, VenderName, VenderAddress, FamilyStab (1250-amount used/authorized), Benefits (750-amount authorized), ExpiredVoucher (DateIssued+32), VoidedVoucher, WarrantDate, Warrant#, WarrantAmount, Fiscal Worker.
I have a One to Many relationship: CustomerID to Voucher# because a customer can come in and receive several vouchers for services up to the max amount (1250 for FamilyStab, 750 for Benefits).
The 1st PRC form I created. I had one with all the fields listed but separated by using a rectangle. Customer info at top, services at bottom.
I can enter the first customer fine; then when entering the next customer, I would get a record dataset error. So, I messed around with the tables and the form and I think I messed up something else. So I recreated the database again and the form. Now I don’t get the error (however, I have no clue what I did). This time I can enter the first person and a second person….but it will not save the second person. I can enter data into both tables so I now think it is my form. I have attached a copy of my form.
I tried I big table and I can enter multiple people. NOW, I can’t enter multiple services for same person. Example: Karena Carrington comes in to get auto assistance. She will need 3 vouchers because there are 3 different issues with her car. 1 is tires so that will need a voucher to Firestone for $200, 2 is muffler so that is Midas for $160 and 3 is air conditioning and brakes and needs parts from AutoZone for our garage to repair at $60.45. She now has a balance of $329.55 for future use within the calendar year.
My one question is: What do I need to do to make the database work?