I run a business that has three types of customers. They are retail, commercial, and industrial, where ie, retail requires less fields than commercial or industial customers. Additionally, we perform multiple services to some or all customers (not labor/time trackable) along with selling various types of inventory. Could you steer me in the right direction to construct tables?
Reply from Alex Hedley:
You could create 4 Tables, 1 with the generic values that all will use, then a new table for each of the three, Now link them with a key. You could then have sub forms or panels and only show those if they choose a type
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 1 Lessons.
The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.