Pick from list

[JurgenG]

Hi,
(example simplified for sake of brevity)

I have a table called "ingredients"
I have a table called "recipies"

Now, I'd like to create a form where a user can create a recipe.
In a subform, all the ingredients should be listed, so the user can click to select the applicable ingredients.

Is this possible?
How would you approach this?

P.S. As for the processing of this "many-many" table, I created an intermediate table "IngredientsInRecipies" only containing the RecipeID and the IngredientID.

 

[Ranman256]

You need 1 more table, tRecipieMix
The tRecipieMix table has fields:
RecipieID,IngredientID,Qty


Put the tRecipie table in a singe record form,
Put the tIngedientMix table in a sub form.
Then the RecipieID will auto populate.
Add IDs from tIngrdients.

 

[JurgenG]

Hi RanMan,

as you can read at the bottom of my post... I already have a mixin table. The issue I want to tackle, is just having a "click and select" view...

 

[MarkK]

Use a ComboBox on the IngredientID field such that the combo looks up the ingredients. The user sees the ingredient description, but the combo stores the IngredientID (bound column) in the underlying field.

Properties of the combo you'll need to be concerned with are RowSource, ControlSource, maybe RowSourceType, BoundColumn (on the property sheet Data tab), ColumnCount, ColumnWidths (on the property sheet Format tab).