Hello,
I am hoping I could get some advice from experts here. Im trying to create a Job board that pulls some data in a linked database. I need to add some unbound fields because I am unable to add the fields in the linked database as I dont have access to add new fields.
Here are the fields I need to set up for the Job board form: (datasheet view)
Job No. > JobDate >CaseName>DueDate - these fields are pulling from the linked database table
The additional fields are:
Assigned to > Priority > Job Status - these fields are showing unbound in the design window. I tried to make these fields as a ListBox to select values for each JobNo. however, when I select a field value in the Assigned to, it automatically select the same value in all records.
I attached a screenshot of the datasheet form.
Is there another way to make this work? Hope to hear from you.
Thank you in advance!
I am hoping I could get some advice from experts here. Im trying to create a Job board that pulls some data in a linked database. I need to add some unbound fields because I am unable to add the fields in the linked database as I dont have access to add new fields.
Here are the fields I need to set up for the Job board form: (datasheet view)
Job No. > JobDate >CaseName>DueDate - these fields are pulling from the linked database table
The additional fields are:
Assigned to > Priority > Job Status - these fields are showing unbound in the design window. I tried to make these fields as a ListBox to select values for each JobNo. however, when I select a field value in the Assigned to, it automatically select the same value in all records.
I attached a screenshot of the datasheet form.
Is there another way to make this work? Hope to hear from you.
Thank you in advance!
Attachments
Last edited: