Filtering contacts from a specific client

Hi, have a look here in the topic 'Constraints' :

https://ninoxdb.de/en/manual/tables/table-references-and-relations

or do a forum search on constraint...

Steven

I was searching for the same issue. Sadly the link KSRoSoft_Steven  posted doesn't work anymore. I looked for other "constraints" related posts but couldn't find anything which addresses my issue. Anyone can help?

Constraints are not very obvious. Since you didn’t tell us what your fields are I’ll use the example from this original 3 year old post.  When you open the constraint window on the left hand side you would see something like:

a.Quotes
b.Contacts

“a” is the table you are in.

”b” is the reference field you are trying to constrain.

So you just need to match on Client:

a.Client = b.Client

Here is the link to the constraints. Scroll down till you find the right paragragh.

Next time please start a new post, so you can mark a question “answered” if you do get it answered.

Fred Thank you and sorry that I posted in here. I did so because it's the same issue.
Also following you advice didn't help.

I have a CLIENTS table and a subtable CONTACTS with the contact persons of each client.

Then I have Quotes and inside their I have a reference field to CONTACTS named ATTN which is a Combo Box.

If I got to ATTN and Contraints, that's what I get.

I tried many variations as I am not sure what to select, mainly under b (Contacts).
Just the field "Name"? Doesn't work. Or Company / Contacts / Name? Doesn't work neither.
I completely confused :(

I guess the data modell is not much of a help either.

Mel shows a good use of the dynamic choice field.

If you want to stick with your example, take a look at my sample. Just select the Quote table. The other tables are from another test.

You will see that the code for ATTN is:

a.Company = b.Company

You can change the name for the reference field in Quotes for Company to Customer but it won’t really change the results.

Fred and Mel Charles Thank you both for your help. I've learned a lot from it. It still didn't work on my end until I rebooted my team. Worked right after that. Not sure this was the issue all along, but as mentioned, I gained a lot from your posts and the sample databases. Thanks again

Fred - I like your approach too - straight forward yet elegant! I quite like my approach by using the dynamic choice if only that if i wanted to edit the contact to select another one,  I could just do it and not have to click the linked field to clear it and then select a new one (yes I know no big deal but ....) - however what do you think the limitation would be if i scaled this up to say over 2000 companies with between 1 and 4 contacts per customer- do you reckon there would be some degrading of performance? in my method versus your method of linking the two tables? 

what say you ?

Bernd Krell - Glad you are sorted !

Mel Charles said:
however what do you think the limitation would be if i scaled this up to say over 2000 companies with between 1 and 4 contacts per customer- do you reckon there would be some degrading of performance? in my method versus your method of linking the two tables? 

Very good question. I would think that the implied filter of:

Customers.Contact

would be very fast.

I don't think you would see any performance hit with the constraint method until maybe you hit 10,000 or 100,000 companies. But what do I know.