No Problem. The Address field on the customer record should either not live there at all or if there is one it would just be [Billing Address].
Then you will make a Table called Shipping Address and Make a relationship where
One Customer has Many Shipping Addresses.
Then I assume that your app probably has orders in it and the on the order table you select the customer. Instead of looking up the address from the customer instead you will make a new relationship where one shipping address has many orders.
The magic for that is that then you go to the field for related shipping address on the order and edit the field properties and mark that field as
Conditional.
You are then specify that once the field for related customer is chosen on the order than only offer up shipping locations we are related customer matches that field. The effect of that is once you choose a customer then the drop-down list of shipping address will just be a short list of possible shipping addresses for the customer you already selected.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com------------------------------
Original Message:
Sent: 08-04-2022 15:18
From: Unknown User
Subject: Creating projects for builders using a new site address
I am very new to the system. For my company, I am trying to figure out how to add a new project for a builder using the new site address, without having to create multiple customer entries with new addresses.