Newbies Martin_01 Posted March 11, 2021 Newbies Share Posted March 11, 2021 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 comment Share on other sites More sharing options...
comment Posted March 11, 2021 Share Posted March 11, 2021 (edited) 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 March 11, 2021 by comment Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 1143 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now