This content has been marked as final. Show 1 reply
You are currently selecting staff names in the portal, but your relationships from the incomes<-->staff is based on IDs, not names. You should be entering the staff ID using a value list based on the staff IDs.
I would also suggest:
- Enter all staff in a single table. Add an indicator field which is true if the staff is a bar staff or dancer.
- All income should exist in a single table. This will make reporting and schema much simpler. The process of normalization reduces redundancy and produces well-structured relations.