Recent content by sethugec29

another simple solution in VBA. "Me.Field1.Visible = True" with an "if" statement. not sure of the impact on the Database performance

Completely understand Pat.... thank you for your detailed explanation ! I going to try to implement this strategy!

Thanks everyone for the great input !

True lol I meant to write Parent instead of sister . Updated.

In a "One to one" relationship can the child record be left empty with the key...so the the record can be fill in at a later stage. What I have noticed it that at least one field of the child record must be filled out in order for the a actual record to be created in child table...

Hi Pat, thanks for the input! A demo would be great if you could spare the time, without releasing any sensitve info from your side :). Would it be possible to post a example of both options ? I would just need the rough concept, so that I could adapt it to my application. Quick question...

Yes i see your point, certain records in the "global table" would simply have no entries in the fields based on the category, any idea on how to set up the form ?

Hi Arnelp, The category tables are meant to be predefined with respective fields, the only thing that changes is what fields are presented to the user. example: (c1 table has field a, b and c), but (c2 table only has fields b,c and d). The question was more do with the setuping the user...

Hi Everybody, Im designing a Product Database. Attached is a processflow/ schematic of how I want want the data entered and stored. Can someone please point me in the right direction. I need to be able to add more fields in final tables and more product categories(i.e. tables). Thanks...

Hi Every Body ! I am a Engineer from Canada, I am interested in improving my workflow, so I would start building a product Design Data using Access. ChilanS