Linking 3 unrelated tables in a form

[jdusa]

I am making a db for my recipes – I have three tables Name, Ingredients, and Directions.

All three tables have a field named Recipe Number. The one in the Name table an auto fill number

The Name form is the main form, and the ingredients and directions are sub-forms. I can get the recipe number to pass for the main form to the each sub-form but when I can not get it to save in the table these separate tables (Ingredients and directions) support.

Any ideas how I can achieve this would be greatly appreciated.

Respectfully,

joe

 

[MajP]

This recent thread was all about linking three subforms.

Passing Context Between Forms

Hello everyone... I'm trying to do something with forms and sub-forms that I think *should* be possible, but I'm struggling with the implementation. I'll try and describe what I'm trying to achieve in 2 ways - a high level "what I'm trying to show" and then "how I'm trying to get there". Whilst...

www.access-programmers.co.uk

 

[silentwolf]

Hi,
just for your information "Name" is a reserved keyword in Access and you should not name your tables "Name".

 

[theDBguy]

Hi Joe. I know you joined a long time ago. But since this is only your second post, welcome to AWF!

 

[HillTJ]

Pat, Great Demo. I particularly liked your 'dynamic' menu method. I've always hardcoded my menu options & was thinking of some kind of dynamic menu. Helped a lot. I also liked the way you captured 'changes' to objects with the sys table. Stuff I'll try and adapt.

 

[Mylton]

Glad you found the sample useful. Not many people examine them that closely so good for you

PS, the menu is based on the A2K switchboard which was the last one before they switched to embedded macros. I did expand it though to allow for more than 8 items. I have a different example for that if you want it. I've posted it many times and it might be in the samples

Good afternoon.
just following up.
If you could post or direct where I can find this other example I would be grateful.

 

[Mylton]

Muito obrigado = thank you so much

 

[HillTJ]

Pat, thanks from me too. Cheers.