The querys do work! I think what I was doing was testing the queries by stringing them all together, and when I tried to enter data I got an error message saying,"Field not up-datable". But if I enter data into one query with Species and Plant data, and close it, then I can enter Plant and location data.
In any case, you have solved my problem. Thank you.
Mo
Mo Ewing
Last Activity: Feb 19 '11, 07:45 PM
Joined: Feb 15 '11
Location:
-
Mo Ewing replied to How can you split data in 1 field (first and last name) into 2 fields (first, last)?in AccessWorked perfectly. Thank you so much!Leave a comment:
-
Mo Ewing replied to How to relate one table to two other tables each with a one-to-many relationship?in AccessThe Species_Name in the Plants table is where the Species_Name used to be, so that field will be deleted when I get the Species Table set up and working. Sorry, I should have taken it out for this discusion.Leave a comment:
-
Mo Ewing replied to How to relate one table to two other tables each with a one-to-many relationship?in AccessHere is a jpeg of the table relationships....Leave a comment:
-
Mo Ewing replied to How to relate one table to two other tables each with a one-to-many relationship?in AccessAccess will produce a PDF of the relationships table but I don't know how to attach it to this message.Leave a comment:
-
Mo Ewing started a topic How can you split data in 1 field (first and last name) into 2 fields (first, last)?in AccessHow can you split data in 1 field (first and last name) into 2 fields (first, last)?
I have a field in my database with people's names. Each field has only one first name but may have more than one last name. The first name is always the first word in the field. I would like to split this field into two fields, first name and last name. Can I construct an action query to do that for me? -
Mo Ewing replied to How to relate one table to two other tables each with a one-to-many relationship?in AccessYes. Species has speciesID as an AutoNumber and PrimaryKey, Plants has one called PlantsID, PlantsToLocatio n has PlantsToLocatio nID, and Locations has LocationsID.Leave a comment:
-
Mo Ewing started a topic How to relate one table to two other tables each with a one-to-many relationship?in AccessHow to relate one table to two other tables each with a one-to-many relationship?
I have one table called "Plants" that has a many-to-many relationship with a table called "Locations" through a third table called "PlantsToLocati ons". This setup works fine. I have a form where I can open a location and enter a list of all the plants found there.
Now, the problem is that individual plants may have two (or more) scientific names and I want to be able to search a name field for either...
No activity results to display
Leave a comment: