Mac OS Catalina 10.15.1
I am creating a database to record visits to pubs, Pub info, Date, Time of receipt etc. I also have a table at the bottom that will record who had what and it broken down into Name, Category, Sub Category, Product, Volume and price.
Name. Category. Sub Category. Product. Vol. Price
The name is easy I have just done a list box linked to a table with the names in.
However in regards to the Category, Sub Category, Product & Vol. I want these to filter down so that I am not having to scroll through loads products.
I am using list boxes for all the below too.
For instance when Alcohol is selected in “Category” only the “Lager” and “Wine” would show up in in Sub category, then equally only “Carling” & “Fosters” will show up in product. and for each of them only half or pint will show up in vol
As it stands because I cannot get the filters to work I am getting a list of every sub category, product and lost of Vol even duplicated vols as I have entered Half and pint for 2 lagers it appears twice.
I have linked all the tables with 1-many relations ships and created an input form to enter the the different prouducts.I have attached the database.
The form I am trying to do this in is, “List Box Datasheet”