I have a simple database which holds names. Each of these names belongs to a different group say red, green and blue.
These group names are held in a related table so that more groups can be added if required.
When the program starts up the group can be chosen on the main menu in a combo.
I need to be able to show this group by name as a reminder on another form showing a list of these names in that group.
I also need to have this group name showing in the same text box as a default when entering a new record.
I have tried creating a text field which copies what is on the combo on the main menu but all it will show is the ID number for the group. How can I show the text red green or blue.
These group names are held in a related table so that more groups can be added if required.
When the program starts up the group can be chosen on the main menu in a combo.
I need to be able to show this group by name as a reminder on another form showing a list of these names in that group.
I also need to have this group name showing in the same text box as a default when entering a new record.
I have tried creating a text field which copies what is on the combo on the main menu but all it will show is the ID number for the group. How can I show the text red green or blue.
