@ChadBishop The way you have set up ID as the PK in your parent table and ParentID as the FK in your child table is the traditional way of doing relationships. In Dataverse this is called Lookups. But real relationships (1-many and many-many) are handled differently. Infact Dataverse does all the heavy lifiting (managing PKs, FKs etc.,).
To set up a relationship, you don't need a FK. You have to select the Parent table and then go to the relationships tab to set up the relationship,
In my example, I have a 1-many relationship between Event and Event Attendance (i.e 1 event can be attended ny many attendees). I don't have any FKs for this in the Event Attendee table. Dataverse will handle all this.
In your App, you will use Relate() and Unrelate functions to create/remove those relationships between records. You will access the related records using the dot (.) notation.
For example, If I have a gallery with the Events and I want all the Event Attendances displayed in another gallery, the items property for this gallery will be,
I don't need to do any Filter with PK, FH etc.,
Hope this gets you going!
