I have setup a simple test database before creating a more complex one, and I am having trouble with the form design.
I have a Table (Plasmids) with an auto-valued primary key (Plasmid_ID) and several other fields relating to the plasmid (Plasmid_name, Created_by, Backbone, Length, etc.)
I have another table (Features) that has an auto-value primary key (Feature_ID) and fields relating to the feature (Feature_name, Sequence, Function, Notes, etc.)
I have setup a junction Table (Plasmid_Features) that has a dual primary key of the fields Plasmid_ID and Feature_ID that are both integers.
I have setup the one to many relationships.
I am trying to create a form that has the plasmid information as the main form, and a subform where I can add features (and to check if the feature already exists, by checking the sequence before adding the entry) and have Features table and the Junction table update.
I can not figure out how to do this in base.