Unrelated Databases Follow

0
Avatar
Legacy Poster

(Using 2016 version)

 

I would like to select a database record using the data entry form to populate two fields on a label.

 

Then I would like to select a record (on data entry form) from an unrelated database in order to populate three more fields on the label.

 

Whenever I try to use more than one database, bartender requires that I link them.

 

I'm only trying to populate fields on the fly in a data entry form, so why would I be required to link the fields?

 

Could someone explain a better design option? I'm not able to use drop down because it's only compose of 1 field.

 

As an example I have a part number and a description. I need a single drop down box that would populate the part number and description in two different fields.

 

 

Anyway, I hope someone understands my confusion and shed some light on this.

 

Thanks

 

 

2 comments

0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

You can have only one connection for your main database data sourcing, although this connection can be for a relational database.  You can also link to other database tables for a loop-up list item.

0
Avatar
Legacy Poster
Comment actions Permalink

Yes reading the fine print, I discovered  that the data picker can only be used for one database, unlike the drop down boxes. So I used two drop downs for my first two fields and then the datapicker for the remainder.

Although as far at the software design goes, I don't see why it's necessary to only restrict it to one main data source.

Please sign in to leave a comment.