How to setup filter properties for fields in a table

[nika.duncan]

Hey all,

Happy new year to all. I am have created the following tables: VehicleInfo, VehicleMake, VehicleModel, VehicleType and VehicleDetail. I want a situation for the VehicleInfo table where once I select the Vehicle_Make that only Vehicle_Model that are affiliated to that make selected will be filtered. I have just started working on this and want to ensure that the properties for the tables are setup properly. Please see attached file below for any assistance possible.


MotorVehicle_FuelTracker1.zip

Thanks,
Nika

[Welshgasman]

You need relationships using foreign keys (FK) in child tables.

[xps35]

You will first have to properly set up the relationships between the tables. For example Vehicle_make in VehicleInfo must be of the same type (long integer) as VehicleMake# in VehicleMake.

What you want to realize is called cascading comboboxes. Just look it up.

Better not use special characters in fieldnames.

[ArviLaanemets]

Don't work with tables except only in design time - to test your app! The best approach is to hide all tables from user(s) after your design is working, and enter/edit data only through forms (you have much more control over your data this way).

And don't use combos as table fields!