Hello
I have recently made the jump from Excel to Access. I'm in the process of converting my Excel Spreadsheet (The Monster) to Access. I have built the tables and now establishing relationships!
The problem I have relates to two tables.
Table 1. Contains fields that build a unique name for an item from five fields.
Table 2. Contains multiple bookings against an item (five fields) in table 1.
However, I may have unnecessarily complicated the relationship as I need to add underscores between each concatenated field in table 1 for ease of viewing and deciphering by the user. But as soon as i do this it presents problems with establishing relationships!
Is the concatenation of fields without underscore relevant and placement of underscores more relevant for forms and reporting?
any assistance is appreciated