I just don't get it. I want to make related databases but it rarely works.
I have a simple database to log cycle rides.
the idea is that I go cycling once a day, sometimes I pass through lots of villages, sometimes only a few. I want to be able to set up a form to enter new rides, and use a subform to enter the places that I rode through.
the tables are: (the ID fields are keyfields)
---
tblRides:IDride, date, duration, mileage
---
tblroute:IDride, IDplace
---
tblwaypoints: IDplace, placename, county
I just cannot get the tables to relate properly. Even with ID fields set to the right type, the relationships always fail. It tells me that it requires the key fields to be of the same type (done that).
So my question is - is there a way to set up a simple relationship so that it works? There is nothing in the many textbooks I have that helps here. I have 3 that I followed step by step , with screenshots for each and they still give inexplicable error messages.
I'm not really a new user, because I have struggled with this for at least a year on and off. This really is the only program I get annoyed with it just seems to be lucky-dip whether it's going to work or not. Is it true that you all get this basic function going. I have asked the technicians at work and they can't get these files to work in a predictable way either.
I actually have one such database that does work, I got as far as making the form/sub-form and it all seems just right. Others before and since refuse to co-operate. Why does it seem to random?
I am using office 2000.
I have a simple database to log cycle rides.
the idea is that I go cycling once a day, sometimes I pass through lots of villages, sometimes only a few. I want to be able to set up a form to enter new rides, and use a subform to enter the places that I rode through.
the tables are: (the ID fields are keyfields)
---
tblRides:IDride, date, duration, mileage
---
tblroute:IDride, IDplace
---
tblwaypoints: IDplace, placename, county
I just cannot get the tables to relate properly. Even with ID fields set to the right type, the relationships always fail. It tells me that it requires the key fields to be of the same type (done that).
So my question is - is there a way to set up a simple relationship so that it works? There is nothing in the many textbooks I have that helps here. I have 3 that I followed step by step , with screenshots for each and they still give inexplicable error messages.
I'm not really a new user, because I have struggled with this for at least a year on and off. This really is the only program I get annoyed with it just seems to be lucky-dip whether it's going to work or not. Is it true that you all get this basic function going. I have asked the technicians at work and they can't get these files to work in a predictable way either.
I actually have one such database that does work, I got as far as making the form/sub-form and it all seems just right. Others before and since refuse to co-operate. Why does it seem to random?
I am using office 2000.