Ok....Pardon my ignorance. Although the web is full of resources, I still cannot find a way to make that works.
I found out that it is better to use a dblookupcombo instead of a dbcombo. Indeed, the dblookupcombo pulls my data from the set listsource and listfield.
Now when i make a selection and it shows up in my box, where can i put the statement that will populate my other table?
I have a table called project. It has
ProjectID
ProjectName
ProcessID.
My combobox pulls data from a Process table that has:
ProcessID
ProcessName.
When a user select a processname from the combobox, i would like its processid to be populated in the project table.
Maybe i am doing it the wrong way. Maybe when i create the Project record, I should pull the processid from the combobox.
What should I do?
Thanks.
Pierrotsc
I found out that it is better to use a dblookupcombo instead of a dbcombo. Indeed, the dblookupcombo pulls my data from the set listsource and listfield.
Now when i make a selection and it shows up in my box, where can i put the statement that will populate my other table?
I have a table called project. It has
ProjectID
ProjectName
ProcessID.
My combobox pulls data from a Process table that has:
ProcessID
ProcessName.
When a user select a processname from the combobox, i would like its processid to be populated in the project table.
Maybe i am doing it the wrong way. Maybe when i create the Project record, I should pull the processid from the combobox.
What should I do?
Thanks.
Pierrotsc