No.
Like I said if you have a "many" items you store those as a seconday table KittenBowls
KittenID BowlID 2 1 2 2 2 2 3 1
No.
Like I said if you have a "many" items you store those as a seconday table KittenBowls
KittenID BowlID 2 1 2 2 2 2 3 1
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Hi Minty,
thank you.
Understand.
When we have only one value characteristic it can be in one table.
But when you have more you have to think about choosing between 1:M and M:M relationships.
1:M when you have parentItem which have multiple items characteristic for it. And Junction table when we have many to many relationships.
Yes?
---->
Returning to topic:
I created subform for bowls as you suggested Minty. With subform CatToys i have something like this:
BowlID - there is a combobox with bowls colors to choose.
This is a correct approach?
In SubformBowl i have only one field - BowlID from table CatCholdrenToBowl. Subform has master link field: ID from CatChildren table and from CatChildrentobowl table field CatChildID as Link child field.
IT is working like a charm but this is strange looking for me - create a subform to show only one field...
Please advise,
Best,
Jacek
You can disguise the subform to look like a small list, remove the record selectors, make it look like part of the main form.
And obviously normally you store the ID but display the associated text, by hiding the first column in the combo.
I frequently have forms with 4 or 5 subforms on them, and one with a tab sections that contains 15 in total!
I use a technique where the tabbed sections don't contain the subform until it is selected. When you select another tab the sub form is unloaded from the container object.
This speeds up the form initial loading and reduces processing time as the related tables data isn't loaded unless it's being viewed.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
thank you Minty.
Now i am fully understand.
You are using something like that to change subforms?
https://www.youtube.com/watch?v=r-Z_nhBtJCI
Best,
Jacek
Actually not quite the same - but that is actually a neat trick I hadn't thought of.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓