Okay, so this works as far as putting the information I need into two separate tables (and it needs to be multiple tables, because there can be multiple addresses for each student). Currently when I make a record in _StudentInformation it adds an internal ID that I use to do my joins, which works great for pulling information, BUT, I have no way at the moment to add a record that I can pull back out, because, while the ID gets created for _StudentInformation I have no way of knowing what that ID is for _StudentAddress.
Is there a way to do this? (It’s not the “StudentID” field - That’s something that the user can enter and won’t be reliable for joins).
var StudentRS as new DatabaseRow var AddressRS as new DatabaseRow //Update Information in _StudentInformation table StudentRS.Column("StudentID")=StudentIDField.text StudentRS.Column("GradYear") = GradYearField.text StudentRS.Column("FirstName")= FirstNameField.text StudentRS.Column("MiddleInitial")= MiddleInitialField.text StudentRS.Column("LastName")= LastNameField.text StudentRS.Column("DOB")= DOBField.text try Session.db.AddRow("_StudentInformation", StudentRS) end try //Update Information in _StudentAddress table AddressRS.Column("Address") = HomeAddress1Field.text AddressRS.Column("Address2") = HomeAddress2Field.text AddressRS.Column("City") = CityField.text AddressRS.Column("State") = StateField.text AddressRS.Column("PostalCode") = ZipField.text AddressRS.Column("Plus4") = PlusFourField.text try Session.db.AddRow("_StudentAddress", AddressRS) end try