If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Record source on subform
I know this is likely an elementary and stupid question, but I don't know how
to do this. I have designed a database & want to have a form for data entry. I want my subforms to draw records from different tables. 2 of my tables a tblContacts tblBusiness tblContacts has home address info, tblBusiness has work info (since there's a many-to-many relationship for some contacts/businesses). The main form is based on tblContacts. I can't figure out how to make the subform "business" draw info from tblBusiness. Help? Thanks! -- Thanks for your time! |
#2
|
|||
|
|||
Record source on subform
I presume you have a main table for contacts, a main table for business and a junction table that connects the two? What do you want to enter into you entry form? "Sue" wrote: I know this is likely an elementary and stupid question, but I don't know how to do this. I have designed a database & want to have a form for data entry. I want my subforms to draw records from different tables. 2 of my tables a tblContacts tblBusiness tblContacts has home address info, tblBusiness has work info (since there's a many-to-many relationship for some contacts/businesses). The main form is based on tblContacts. I can't figure out how to make the subform "business" draw info from tblBusiness. Help? Thanks! -- Thanks for your time! |
#3
|
|||
|
|||
Record source on subform
I'm trying to normalize as much as possible so I wanted to separate tables
containing business and personal information. On the business subform, I want to enter contact info (address, phone, pager, etc.) -- Thanks for your time! "scubadiver" wrote: I presume you have a main table for contacts, a main table for business and a junction table that connects the two? What do you want to enter into you entry form? "Sue" wrote: I know this is likely an elementary and stupid question, but I don't know how to do this. I have designed a database & want to have a form for data entry. I want my subforms to draw records from different tables. 2 of my tables a tblContacts tblBusiness tblContacts has home address info, tblBusiness has work info (since there's a many-to-many relationship for some contacts/businesses). The main form is based on tblContacts. I can't figure out how to make the subform "business" draw info from tblBusiness. Help? Thanks! -- Thanks for your time! |
#4
|
|||
|
|||
Record source on subform
Sorry, what you are trying to achieve isn't very clear. What distinguishes business and personal information? "Sue" wrote: I'm trying to normalize as much as possible so I wanted to separate tables containing business and personal information. On the business subform, I want to enter contact info (address, phone, pager, etc.) -- Thanks for your time! "scubadiver" wrote: I presume you have a main table for contacts, a main table for business and a junction table that connects the two? What do you want to enter into you entry form? "Sue" wrote: I know this is likely an elementary and stupid question, but I don't know how to do this. I have designed a database & want to have a form for data entry. I want my subforms to draw records from different tables. 2 of my tables a tblContacts tblBusiness tblContacts has home address info, tblBusiness has work info (since there's a many-to-many relationship for some contacts/businesses). The main form is based on tblContacts. I can't figure out how to make the subform "business" draw info from tblBusiness. Help? Thanks! -- Thanks for your time! |
#5
|
|||
|
|||
Record source on subform
Sorry to obfuscate.
Personal info is home address, etc. Business info is work address, etc. For some people, I have - and need - both. -- Thanks for your time! "scubadiver" wrote: Sorry, what you are trying to achieve isn't very clear. What distinguishes business and personal information? "Sue" wrote: I'm trying to normalize as much as possible so I wanted to separate tables containing business and personal information. On the business subform, I want to enter contact info (address, phone, pager, etc.) -- Thanks for your time! "scubadiver" wrote: I presume you have a main table for contacts, a main table for business and a junction table that connects the two? What do you want to enter into you entry form? "Sue" wrote: I know this is likely an elementary and stupid question, but I don't know how to do this. I have designed a database & want to have a form for data entry. I want my subforms to draw records from different tables. 2 of my tables a tblContacts tblBusiness tblContacts has home address info, tblBusiness has work info (since there's a many-to-many relationship for some contacts/businesses). The main form is based on tblContacts. I can't figure out how to make the subform "business" draw info from tblBusiness. Help? Thanks! -- Thanks for your time! |
#6
|
|||
|
|||
Record source on subform
So you have a personal info table and business contacts table. You can't enter information into a subform until the info in the main form has already been entered (as least that is how I see it but maybe I am wrong on that) All I see is that you select the ID from the business table into the FK field in the junction table. What you need to in the form wizard 1) select all the fields for your form 2) select all the fields for the junction table 3) create the form and subform 4) The ID field for the business info should use the main table as its source. I appreciate that probably isn't very clear. "Sue" wrote: Sorry to obfuscate. Personal info is home address, etc. Business info is work address, etc. For some people, I have - and need - both. -- Thanks for your time! "scubadiver" wrote: Sorry, what you are trying to achieve isn't very clear. What distinguishes business and personal information? "Sue" wrote: I'm trying to normalize as much as possible so I wanted to separate tables containing business and personal information. On the business subform, I want to enter contact info (address, phone, pager, etc.) -- Thanks for your time! "scubadiver" wrote: I presume you have a main table for contacts, a main table for business and a junction table that connects the two? What do you want to enter into you entry form? "Sue" wrote: I know this is likely an elementary and stupid question, but I don't know how to do this. I have designed a database & want to have a form for data entry. I want my subforms to draw records from different tables. 2 of my tables a tblContacts tblBusiness tblContacts has home address info, tblBusiness has work info (since there's a many-to-many relationship for some contacts/businesses). The main form is based on tblContacts. I can't figure out how to make the subform "business" draw info from tblBusiness. Help? Thanks! -- Thanks for your time! |
Thread Tools | |
Display Modes | |
|
|