Reffering a table into another one

[quintasmatheus]

Hey guys, I have a problem in my app.

My app consists in an inventory management of automobile parts.

I'm using two tables. One its the main one where I have the autoparts available at my storage and some more details, the second one its a table that only contains the references and materials that I apply to those autoparts. 

So imagine that I have a seat injector in table one, and want to reference that i've used the materials x,y,z to repair it, how can I do that? When I reference the second table in the first table, it only allows me to reference the material x.

[Austin_QREW]

Hi @quintasmatheus ,

It looks like your on the right track.

Here is a quick answer to your question: 

You will need to use an Enum List with a base type Ref. You may also need to use a Valid if - Table Name[ID]

Additional Resources 

Here is our Inventory App for the Automotive Industry 

And here is a link to the Webinar.

Hope this helps, let me know if you have any other questions and I will try to help as best as I can.

Thanks,

Austin from AppSheet Training

[quintasmatheus]

Hi Austin thanks for the reply, now I have another error, I want to save an ID to be the key of my second table, but it doesn´t allow me to.

Thank you for the help!

[quintasmatheus]

When I try to save the configuration it takes off the key attribute from the ID

[Austin_QREW]

It looks like you have 2 key columns selected. You should uncheck the key column - _Rownumber