Adding multiple MATERIALS to a single JOB with a s...

ubi · 03-03-2022 08:11 AM

hi i have 2 tables JOBS and MATERIALS.

each JOB will have none or multiple MATERIALS.

is there any way that when i create a new JOB entry i can also add as many MATERIALS to that job as is needed? bearing in mind that when the MATERIALS are added they will be new entries too, as in not already in the MATERIALS table.

hope this makes sense.

thanks.

SkrOYC

Have you seen this?

https://help.appsheet.com/en/articles/961426-references-between-tables

ubi

no i hadn't.. will go take a look!

thanks.

SkrOYC

At least that's one way of doing it, although is not the path I would take personally.

The "right" way IMO is by just using a Ref to the Materials table. This generally makes a dropdown where you can search for the items you want to select.

If one of them is not available, you can create it.

Now, since you are selecting more than one material, EnumList basetype Ref could help.

Please take a look at this video from @MultiTech to see if it's what you need:

https://www.youtube.com/watch?v=q4xCzxPgbaU

Adding multiple MATERIALS to a single JOB with a single form