Hi
I am still new to access and have some basic questions. I have a table that I can set up two or three ways and I don't know which is proper. The first field is plot number which is a simple 4 diget text string that identifies a plot, the second is project number which identifies the project that the plot is associated with and the third is simply the year. I did it this way so the same plot number can be used for different projects or with the same project in different years so I don't have to keep seperate tables for each one. This works as long as make all three primary keys to keep from having duplicates. Would it be better to have seperate tables for each one or put them in one field and number them like xxxx.ppp.yyyy and when I querry them sort them out. The relation is one project can have many plots which can have only one year. Any ideas would be appreciated.
Thanks
GW73
PS. I won't be able to check this until tomorrow
I am still new to access and have some basic questions. I have a table that I can set up two or three ways and I don't know which is proper. The first field is plot number which is a simple 4 diget text string that identifies a plot, the second is project number which identifies the project that the plot is associated with and the third is simply the year. I did it this way so the same plot number can be used for different projects or with the same project in different years so I don't have to keep seperate tables for each one. This works as long as make all three primary keys to keep from having duplicates. Would it be better to have seperate tables for each one or put them in one field and number them like xxxx.ppp.yyyy and when I querry them sort them out. The relation is one project can have many plots which can have only one year. Any ideas would be appreciated.
Thanks
GW73
PS. I won't be able to check this until tomorrow