Linked Data and Unbound Fields

vince1818

Registered User.
Local time
Yesterday, 16:44
Joined
Apr 8, 2015
Messages
34
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!
 

Attachments

  • DataSheet Form Screenshot.JPG
    DataSheet Form Screenshot.JPG
    54.7 KB · Views: 74
Last edited:
I don't understand. If you add unbound fields to a form, and people enter data in those fields, that data will be lost.

Data is stored in tables, and fields on forms are just visual tools to interact with data stored in a tables. If you don't control a table, but you want to store related data, you need to create a table, link it to the table you don't control, and bind the new fields to your new table.
 

Users who are viewing this thread

Back
Top Bottom