I created the earlier thread "How lookup fields stem from one another" and this question is related to that.
I have a database of fossils from a particular location. I have the tables
tblFossilCat (my main table)
tblFormations (geologic formation)
tblMember (specific member of particular formation)
tblClass (Class of organism)
tblOrder (Order within preselected class)
tblFamily (Family within preseleced order)
tblEpoch (time Epoch)
tblPeriod (time period, within preselected Epoch)
I have a lot of fields that feed off of one another, [Formations and Member], [Class, Order, and Family], and [Epoch and Period.]
I used combo boxes in my forms to create these relationships.
Now, my problem is I used autonumber fields such as ClassID to refer to CName (Class Name) when I created my combo boxes. This was necessary because of some duplication. Anyway, now I want to make a feature that will enable a user to print out a report of a particular class of animals - for example mammals, or a list of the fossils sported by class (mammals, fish, etc.) The problem is that now in my tblFossilCat, which I am basing my reports from, I have reference numbers (ClassID) instead of class names, and this is what is displaying in my report. I's like to change that so that the names are displaying in my report instead of the numbers. Everything is being input with the form frmFossilCat, which contains those combo boxes.
I got the earlier advice to link my tables with a query or to use a combo box in the report. I can't preanticipate what Class a user will be searching for, so I think a combo box might be too complicated. I have a hard time understanding how queries work, though, so I'm not sure if that is what I need to use! Help! Please, don't assume I know anything about Access! I'm learning.
I have a database of fossils from a particular location. I have the tables
tblFossilCat (my main table)
tblFormations (geologic formation)
tblMember (specific member of particular formation)
tblClass (Class of organism)
tblOrder (Order within preselected class)
tblFamily (Family within preseleced order)
tblEpoch (time Epoch)
tblPeriod (time period, within preselected Epoch)
I have a lot of fields that feed off of one another, [Formations and Member], [Class, Order, and Family], and [Epoch and Period.]
I used combo boxes in my forms to create these relationships.
Now, my problem is I used autonumber fields such as ClassID to refer to CName (Class Name) when I created my combo boxes. This was necessary because of some duplication. Anyway, now I want to make a feature that will enable a user to print out a report of a particular class of animals - for example mammals, or a list of the fossils sported by class (mammals, fish, etc.) The problem is that now in my tblFossilCat, which I am basing my reports from, I have reference numbers (ClassID) instead of class names, and this is what is displaying in my report. I's like to change that so that the names are displaying in my report instead of the numbers. Everything is being input with the form frmFossilCat, which contains those combo boxes.
I got the earlier advice to link my tables with a query or to use a combo box in the report. I can't preanticipate what Class a user will be searching for, so I think a combo box might be too complicated. I have a hard time understanding how queries work, though, so I'm not sure if that is what I need to use! Help! Please, don't assume I know anything about Access! I'm learning.
