Jump to content

Show record only if ...


Recommended Posts

  • Newbies

Hi all,

so I have 2 tables CUSTOMER and CONTACT,  in the contact one of them is listed as "billing" contact (it's a simple yes or no field ).

I have a form that prints showing customer information (Name, address, phone # ...) and I would like to have the contact that is listed as "BILLING" contact to appear on the form ....

How would I go about this one ... 

Link to post
Share on other sites

You could put a one-row portal to Contacts on your layout, filter it to show only records that have "yes" in the Billing field, and place the fields you want to show in this portal.

However, your current arrangement is flawed: if a customer can have only one billing contact, then the identity of the billing contact is a property of the customer and should be recorded in a BillingContactID field in the Customers table. Then you can define a relationship to another occurrence of the Contacts table matching BillingContactID to ContactID, and place field from this occurrence directly onto your layout. Or you could still use a filtered portal - but I think you will need the relationship for other things too.

--
P.S. For Boolean fields, it is much better to use a Number field with 1 for True and 0 or empty for False. If you like, you can format such field to display as Yes/No. 

 

Edited by comment
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.