RapidFireGT
New member
- Local time
- Yesterday, 20:29
- Joined
- Dec 5, 2011
- Messages
- 6
[SOLVED] Form with inputs to 3 tables - won't accept new data
I'm trying to make a form that will accept input fields that will store data in 3 separate tables. This is for a hypothetical business that is setting up a registration for a new customer, and they are trying to store data regarding the customer's personal information, purchase (membership) information, and payment information.
Thus, the 3 tables are Customer, Membership, and Payment.
Now first off, let me state that I created this form simply by creating a blank form page, and then manually adding all the fields from the 3 different tables. (Down the road, I had planned on having several of the fields auto-filled depending on what is entered into prior fields). I am not sure if this is the correct way to go about it, or if I should be using sub-forms.
Problem: When I add fields from the Customer and Membership fields and set the Form's "Data Entry" property to "Yes", the form is empty and ready to accept new data (which is what I want). HOWEVER, when I add in the Payment fields, all of the fields in the form then auto-populate with data from existing records in the database. If I create this form in an empty database with no records, all the forms simply disappear. Why is it that the addition of the Payment fields causes the form to exit out of Data Entry mode (even though it says it is still in it), and pull in existing data?
Here is an image of ideally what I'm looking to accomplish, with blank fields of course, where I can enter in new customer information. (Note: all data is made up; there is no information pertaining to real people).
(Attachment1)
Here is an image of a quick recreation of the form WITHOUT the Payment fields entered (NOTICE: the fields are all empty, which is what I want).
(Attachment2)
Here is an image of the same form WITH the Payment fields entered, and now all the fields have been populated with existing records. This is the problem.
(Attachment3)
If it helps any, I've also attached an image of the Relationships diagram.
(Attachment4)
Any ideas why this is happening, or if I am even doing this the right way? Should I be using sub-forms instead, and can I accomplish something similar to the first image using sub-forms?
SOLVED: I went ahead and added two sub-forms to my main form, and everything is displaying properly now.
I'm trying to make a form that will accept input fields that will store data in 3 separate tables. This is for a hypothetical business that is setting up a registration for a new customer, and they are trying to store data regarding the customer's personal information, purchase (membership) information, and payment information.
Thus, the 3 tables are Customer, Membership, and Payment.
Now first off, let me state that I created this form simply by creating a blank form page, and then manually adding all the fields from the 3 different tables. (Down the road, I had planned on having several of the fields auto-filled depending on what is entered into prior fields). I am not sure if this is the correct way to go about it, or if I should be using sub-forms.
Problem: When I add fields from the Customer and Membership fields and set the Form's "Data Entry" property to "Yes", the form is empty and ready to accept new data (which is what I want). HOWEVER, when I add in the Payment fields, all of the fields in the form then auto-populate with data from existing records in the database. If I create this form in an empty database with no records, all the forms simply disappear. Why is it that the addition of the Payment fields causes the form to exit out of Data Entry mode (even though it says it is still in it), and pull in existing data?
Here is an image of ideally what I'm looking to accomplish, with blank fields of course, where I can enter in new customer information. (Note: all data is made up; there is no information pertaining to real people).
(Attachment1)
Here is an image of a quick recreation of the form WITHOUT the Payment fields entered (NOTICE: the fields are all empty, which is what I want).
(Attachment2)
Here is an image of the same form WITH the Payment fields entered, and now all the fields have been populated with existing records. This is the problem.
(Attachment3)
If it helps any, I've also attached an image of the Relationships diagram.
(Attachment4)
Any ideas why this is happening, or if I am even doing this the right way? Should I be using sub-forms instead, and can I accomplish something similar to the first image using sub-forms?
SOLVED: I went ahead and added two sub-forms to my main form, and everything is displaying properly now.
Attachments
Last edited:
