I'm trying to create something familiar to a lookup table but that hold another empty column for quantity.
for example I have 10 product in a product list table
I have a shipping container table
when I'm creating a new container I want to have a field for "units" and when clicking on the field I get a lookup table to retrieve the unit list and empty column to insert quantity per product.
the units should be countable and the transfer all the units I have in all container into another table that sums all quantity of all units per product
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
jonathanAa
Hi Guys,
I'm trying to create something familiar to a lookup table but that hold another empty column for quantity.
for example I have 10 product in a product list table
I have a shipping container table
when I'm creating a new container I want to have a field for "units" and when clicking on the field I get a lookup table to retrieve the unit list and empty column to insert quantity per product.
the units should be countable and the transfer all the units I have in all container into another table that sums all quantity of all units per product
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.