How do I show records from other table in a form based on an existing field?

[nightangel73]

I'm trying to build a immunizations record database. I have my form to enter the immunizations but I would like it shows me what vaccines need to be given based on recommended vaccines for the age. I can enter all the imunization information but then I don't know which vaccines I need to add. I would need to look in the vaccine table but I would like that it shows in the form.





Thanks!

[June7]

Could have a combobox list the vaccines. The combobox list could be limited by the age of the patient. This is called a dependent or cascading combobox because the list is filtered dependent on value in another control.

Example: http://www.datapigtechnologies.com/f...combobox2.html

[nightangel73]

Actually a combo box was a good idea to use. It works well. Only problem is I would like the months in ascending order..

I have set up the recomended age as 0 birth, 1 month, 2 month...so if I set this in ascending order then I get 0 birth, 18 month, 2 month. Where I would like the ascending to be 0 birth, 2 months and 18 month in that order..

[June7]

Is this combobox list derived from a table? Need placeholder zeros: 0 birth, 02 month, 18 month, etc, or another field to define sort order.

[nightangel73]

Is this combobox list derived from a table? Need placeholder zeros: 0 birth, 02 month, 18 month, etc, or another field to define sort order.

How about years? what place holder for years 18 months...1 year ..2 years

[June7]

Then I suggest you have another field in table to use for sort criteria.