Re: [MS_AccessPros] How to link to subform on a parent form?

 

Art-

So, the tables should be linked like this:

tblObjectType:ObjectTypeID -> ObjectTypeID:tblObjectField:FieldTypeID -> FieldTypeID:tblFieldType

So, tblObjectField must have a field called FieldTypeID in it that links to the Field Type table.  Does it not?

John Viescas, Author

Effective SQL

SQL Queries for Mere Mortals 

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

http://www.viescas.com/ 

(Paris, France)

On Jun 26, 2017, at 6:44 PM, dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I have my main form called frmObjectType whose record source it tblObjectType. On this form I have a subform sfrmObjectTypeFields whih record source is tbObjectField and another subform called sfrmFieldProperties whose record source is tblFieldType.

Now sfrmObjectTypeFields is tied to the mainform frmObjectType through a field called ObjetTypeID which resides in both forms. 

Now the subform I need to tie together is sfrmObjectTypeFields and sfrmFieldProperties via the FieldTypeID which resides in both form but is not available in the link properties of sfrmFieldProperties. Any Ideas?

Thank you, 

Art Lorenzini

Sioux Falls, SD

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___