Inventory items not showing in Layout

[Lexscious]

Hi,
I added a new item to inventory yesterday and was able to select it to allocate to a project as per normal, but noticed one of my other items, shows up as Inventory and can be selected, but the Cost Per Unit for that particular item, cannot be selected.

I deleted that Item and added it again, but still, it shows as an Inventory Item, but you cannot select the corresponding Price Per Unit.

I thought maybe it was an issue with me having the item number limited, but I can’t see where the issue is.

The bottom two items are the issue, the one above is fine.
Ideas on what to check please?

Thank you

[nathanaelb]

The source of the choice component is a column of the table where you are adding items?

[ThinhDinh]

Is there a reason you have to separate the cost per unit from the item? Is the relationship between item and cost per unit one to many?

I thought it would make sense to have a cost assigned to each unit and you can just do a relation - lookup but I want to know more about your data.

[Lexscious]

(post deleted by author)

[Lexscious]

I tried it, but I couldn’t figure out how to get it to work properly, and this has been working until now.