Limit Database Selection To Just One Record? S’abonner

0
Avatar
Legacy Poster

Hello,

 

I have a database that contains a list of products.

 

We only ever print 1 product (Database record) at a time.

 

Sometimes our operators select the wrong database record then select the correct record without unselecting what they originally clicked on. So they end up printing labels for both products.

 

Can a label be set up so it only allows one record to be selected at a time? If you reselect another record the first record becomes unticked?

 

This would be a great help.

Thanks

5 commentaires

0
Avatar
Ian Cummings
Modérateur
Actions pour les commentaires Permalien

You could set up a query to return only a single record.

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

You could just restrict a record selector on your form to one entry. (Let me know if you need to know the preceding steps.)

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Thanks Ian C,

 

Won't using a query fix the selection i.e. it will always select a certain record.

 

What I'm after is at time of printing only one can be selected.

 

Hello Virtual Graphics,

 

Thanks for your reply.

 

That's not a screen I've seen before, if it helps I'm running 10.1 SR4 is this from a newer version?

 

Thanks for your help.

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

fenboy,

 

Yes, this is from BT 2016; I'm not sure when along the line this feature was introduced, but it should do exactly what you need. It might be worth researching if your version includes it; it may just be in a different menu.

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Thanks VG,

 

Will do.

Vous devez vous connecter pour laisser un commentaire.