|baseportal message board|
Welcome to the baseportal message board...
Please read the FAQ.
|Selected message:||To the list|
|Message from Christoph Bergmann on 3/19 2004, 21:59 +01:00|
Re: Relations - you need to sort the specified field...
...in the database you related to.
|All messages from this thread:||To the list|
|Message from Maurice on 11/24 2002, 17:16 +00:00|
EMail: firstname.lastname@example.org WWW: mauriceward.com
I have a main database. This is my contacts database. I am trying to get a second database to relate to the main database. I need all the different databases to pull info from the main "contacts" database.
In the second datadase, I put "relation". I am asked for "position" which I leave as "new", Feild name which I call say "agent", database, where I choose "main". Finally, the box asks for "key field". I have entered both the position in the main database & the title in the main database but neither works. I get the following error message. I am totally new to this. If someone could tell me what I am doing wrong, it would be great..
Thanks & best regards,
Error: Field Name not defined in database /ward/main
Reason: The field is not defined in the database. Maybe you have just mistyped the query?
Solutions: 1. Correct your query. 2. Log into your private domain, choose the appropriate database, click on 'Fields' and add the desired field. ]
|Message from Christian (cvogeley) on 11/26 2002, 22:43 +01:00|
the problem is that the relations field you are using is a little bit buggy, so that it is probably a better idea not to use it.
If you want to create relations you must do some programming work with perl.
Maybe this link will help: http://baseportal.com/doku/index.html#a29
If not just feel free to ask.
|Message from Wayne Francis on 3/16 2004, 18:00 +00:00|
EMail: waynefrancis@UKonline.co.uk WWW: wayne.francis.name
I have the same problem as Maurice. I want the second table to include a field from the first table. I don't get the error but when entering data for the second table there are no values avaulable from the fist table to choose from.
It is not obvous to me though how your proposed solution will work when I am creating new records in the second table.
Example database is:
Where I wish to join the FirstName field of entries_2004 to firstname of members.
|Messages from 3300 to 3450:||To the input form|
|> Relations from Maurice on 11/24 2002, 17:16 +00:00|
Re: Relations from Christian (cvogeley) on 11/26 2002, 22:43 +01:00
Re: Relations from Wayne Francis on 3/16 2004, 18:00 +00:00
| Re: Relations - you need to sort the specified field... from Christoph Bergmann on 3/19 2004, 21:59 +01:00|
|<< Newest messages | < Newer messages | To the input form | Older messages > | Oldest messages >>|