Feb 2 2005, 10:00 AM
Hi all, attached is a copy of my database. I'm quite pleased with my progress so far. However the part that I am doing now is a bit beyond me. This is where (hopefully) you come in!
If you look at the form called frmtab, you will see a tabbed form/subforms. These subforms are linked to data in my tables. What I want done is for the tabs (forms) that are called Selected Model/Variante, Selected Variante/Group, and Bill of Materials, to only display data based on the selection of the previous tab. Eg. If I select a model on Selected Model/Variante, I only want the Variante for that model to appear in the Variante/Group tab, and then the same with the Bill of Materials tab.
I guess it will require some SQL, but I'm not sure where to put it, or the righ syntax, I would imagine it'd be somethign along the lines of....
Select * from tblVariante Where tblModelVariante.VarianteID=tblVariante.VarianteID
I hope thats clear. If you are kind enough to take a look don't hesitate to ask questions. I can be more specific if neccessary.
Feb 2 2005, 11:36 AM
Base the subforms on queries that are filtered by the subforms that precede them. This article
is about synchronized combo boxes, but the idea is the same. Be sure you have your syntax correct in the criteria lines of your queries...
Feb 3 2005, 05:18 AM
Thanks for the reply, but I've been trying to do this for the past couple of hours, and am having zero success. :(
Is there something else I need to know? My tables are all linked by link tables in a 1 to many to 1 kind of arrangement. Does this need to be addressed? Someone please help I'm at a bit of a brick wall here.
Feb 3 2005, 10:51 AM
You have many redundant and unnecessary tables. For example, tblBillOfMaterials and tblEngineBOM should be one table and on down the line. You need to normalize your structure and then getting your data out will be much easier. I would suggest that you search the archives here for Normalization as there are a number of good article there, including this one