Search results

Sorry guys, i didn't mean to switch posts - will stay with this one I think i am beginning to understand my tables (well...sort of!- still confused to the logic of all this) I need to get a handle on this, because the db I am inputing data into has many lookup tables (for different tables)...

mistake in reply My mistake: The field 'description' in table 3 (not 1) lists 15 barrier types. I believe this is a lookup table. The field" barrier type' in table 1 will contain a record of a particular barrier found at a particular location Does that make a difference to your replies?

Thanks for your explaination I think i understand that look up tables contain values that will be used as the content of a field located in the main table. Here is the original table design i started with (before I started messing around with it: Table 1: Fields: Barriers_id utm_zone easting...

I have been recently been given an empty database that is in the process of being populated from various data sources. Eventually the db will be used in an GIS and mapped. I have 2 tables in a one to many relationship - table 2 is a lookup table: Table 1: Fields: Barrier_id utm_zone northing...

Comments Thanks for your help Yes, i think you are right, a barrier can only have one type (ie: you can't have a barrier that is a dam and a culvert) So it looks like i need a one to many relationship instead. Table 3 (barrier type) is a look up table - the description fields lists a set...

Hello all, I have been given an empty database that is in the process of being populated from various sources. Eventually the db will be used in a GIS and mapped. My question is - could you help me understand how the following 3 tables work together. I am confused (escpecially with table 3) as...

Hi I have a 2 tables: One that is empty (access table called Barriers) and one excel table that has records (also called barriers). They have similar fields. Basically, i want the records from the excel table to be in the access table. I am in the process of populating an empty database...