Creating a BAQCombo in customizated Table

Epicor ERP 10
1

I have a field I am adding to the Maintenance Job Entry Table for our techs to use to identify the “location” of the equipment to repair. This data comes from the EquipLoc table. I created a BAQ so it could pull the data and as the table is updated, the list would get refreshed. I am unclear of the next steps. I have the field in the table but that’s as far as I’ve gotten because I get an error. Below is the screen shot of the field:

image
image.png785×579 44.8 KB

I am not sure if I have the BAQ info correct. Just need a little guidance.

Thanks,

Charles

2

Usually the fields are not using dots but underscore. Look at the full SQL view of your BAQ (the general tab) and it will show the correct names of the fields.

ex: [OrderHed].[OrderNum] as [OrderHed_OrderNum]

so your value member shall be EquipLoc_ID…

Pierre

3

Thanks I will change that. What about the dynamicqueryid? Is it just the name of the query? I have it as Location.BAQ.

I think I did that and I get this error when I right click to search:

image

4

It’s the name of the query, and the value and display are column names that are in your query.

image
image.png1182×640 43.6 KB

5

Well if that is the name of your query… that is the one to choose!
When you load your form, the combo should contain the list.

But I noticed that you did not identify a binding that list should be bound with. When your tech is choosing the location, which field the information should be saved into? That is the binding you should set.

The window you show is not an error, it is a window telling you under design mode, the next form it will open…

Pierre

2 Likes
6

OK. I have that correct then. My epiBInding is set to JobHead.EquipLocDesc. I also created a UD field called location. Should I set it to that? I am still having issues with it displaying anything even if I search for it.

Do I need to add the list to the String array? I thought if I was pulling a BAQ it would not need that?

7

You shouldn’t. You only use that if you want to type in the list (I think)

I think you’ll have to close and reopen the form for the drop down to work correctly.

You need to pick which one you want to set. The UD field, or the other field you have shown. You can only set one.

8

Ok. It’s working. Thanks for the help @Banderson and @Hogardy

1 Like