Populating Dropdown

Need help Database
1

Not sure whether what I want to do is possible or not but essentially I have a drop down that is populated from a table (aircraft types) and when the parent record is created (aircraft) it correctly adds the aircraft type. However I can’t retrieve the aircraft type when I want to update the aircraft record as I haven’t linked the aircraft type to the aircraft record in the database. I opted not to do this as I don’t want to orphan records if I ever delete an aircraft type.

I guess what I really want is to have a dropdown that can give me a list of aircraft types that can be added to the aircraft record (this bit works) then when in update mode I want to set the default of the dropdown to the value set in the aircraft table despite the fact this is just a text field. Is this possible?

See below.

image
image871×495 38.4 KB

2

Hello! I have a similar setup for a couple of farms in an app. What I did is setup a group with a type of farm and on Data source, do a search for a farm first item. Then, on default value, I’ve set to Parent’s farm, so it always get the first item to be my default.

3

Since each aircraft has a type, then you will need to create a link between the 2 tables. About orphan records, you can always manage them using Triggers to manage Cascade Deletes to happen in the background.
I would suggest structuring your DB in the right way to represent the relationships correctly instead of searching for workarounds along the way.
Please let me know if you need any further support from my side. I will be more than happy to help.