Hello John
I did what you said and its coming along just fine.
thanks... edgar
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> 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