Data Entry

[slaman]

Thank you very much for your help in my previous questions... I have the structure of the database all set... but now I am having an extremely difficult time trying to create a form to INPUT the data. Is it me or is the Paradox HELP lacking in a bad bad way? Anyways, this is what I am trying to accomplish:

From a main form, I have a button to "Create New Organization"... All this button does is open a form.

Now in Organizations.db there is an ID... This ID is set to increment for each new entry. I also use this ID to link many databases. When the form first opens, I want to display to the user what this unique ID number is... I cant do it! I've searched the documentation and the tutorials, but all I can display is a blank field. Anyways, I then want to use that ID to input into another database. On the same form, I want to have fields of this other database - one of the fields being the ID which I want to automatically designate upon opening the form. Now I have no clue how to do this... Is there a book maybe someone can suggest that will help me learn this better? If I can't even accomplish this seemingly simple task, I wont be able to implement even close to half of what I had planned...

I appreciate your help.

Here is a sample of the database structure.

Organizations.db
ID (increment)
Name
Address
Etc...

Presidents.db
ID (from organizations.db)
Name
Address
Etc...

Here is a sample of the form I want to create for data entry.

<DISPLAY ID>
Organization Name:
Organization Address:
President Name:
President Address:

But I cannot seem to figure out how to pass along the ID to the second database or even add an entry to this database using a single form!

 

[slaman]

I want to have two databases on a single form (eventually about 10)

I DataInsertRecord from the master database, and I input a value for ID. Once I reach a certain field, I want to DataInsertRecord of a SECONDARY database, with that input ID as this secondary database's fieldValue.

How do I do this? How do I specify that I want a fieldValue for something on my form to input data into an entry for the SECONDARY database?

 

[JoeNg]

Oh, boy. This could take all day.

Ok. Let's start with the PerfectExpert in Pdox 9.
Choose Form and create a form using Data from two tables.

this should give you a good idea on how to create a form with multiple tables.