Edgar-
I assume you designed it that way so that each customer can have more than one
address. You need the IdCompany as a foreign key field in tblAddresses. Then
design a subform on frmCompanyDetail to edit the multiple addresses and make
sure the Link Master / Link Child properties of the subform control are set to
IdCompany.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
rivera_vazquez_edgar
Sent: Thursday, June 02, 2011 2:21 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] I need help with forms
Hello again, Edgar here...
So I made all my tables and relationships, followed normalization rules and
starded to make my forms. My main table is tblCompany, wich has 3 fields:
IdCompany, CompanyName, CompanyType. I've got these fields on my
frmCompanyDetail. I also have another table tblAddresses. How do I include the
company address into this form?
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar