Recent content by Ken Fedak

Thanks very much Pat its works great

Thanks Pat How do I join this information in a Query or report. When I did a query I still recieved the autonumbers.

Fuga Thanks That is exactly what is happening, How do I change the default?

Fuga I have the right fields as control sources, would my problem be with relationships. Let me explain Both tables are linked so when I choose location only the supervisors from that location show in the combo box

The data being stored in the other tables is small and is used for every record. The form has 2 combo boxes which choose location and supervisor. When the form is used the actual location and supervisor does show but only the autonumber is stored in the main form.

I have a form which gets data from other tables and stores it along with other data in a master table. The data I retrieve from the other tables stores in the master as the data's autonumber. How do I get it to store actual data from the other tables rather than the autonumber.

I have one combo box which lists available foreman, I then have two list boxes which list employees. The employees can be selected and move to the second list box. How do I get the list box to list only employees belonging to a certain foreman and when employees are selected have each employee...