Messed up table structure and paying the price

[tonycl69]

Hi all I have attached a table I created years ago, in my access green years. As you can see I have three main fields, 2 are locations from and to that location, and a date field, what I need and am finding it very difficul to get my head round it I need a todate and from date or a onhire date and a offhire date with one location. If you dont want to touch this i will understand. I would like the location the id of the location table.

 

[plog]

Looking at your data, I can't understand what you want. Can you provide some sample data of what you want based on the data in there? Where are these todate, from date, onhire date, and offhire date values coming from?

 

[tonycl69]

That table is backend for a form that is manulally updated, what I need is a many to many scenario so i what place has had what.

 

[Pat Hartman]

I also don't understand what you are trying to do. the data seems to be duplicated. I would expect the combination of From and Date to be unique for some item but that "item" is not included in the table. Did you strip it out to make the example smaller?