1 form -NEW --> 2 DBs

[Leb i Sol]

Is this possible?

Have a one Add.html page with a single form that will insert some of the fields into One.fp5 and some into Two.fp5?

If

A:Yes

my next

Q: what is the syntax?

thanx

[Anatoli]

Fair chance is JavaScript.

Without JS: fill All the fields with single submit to file One.

On response page submit correct fields to db Two with inline.

Or set relationship between One and Two.

I guess there are even more ways...

Sorry, no code available

[Leb i Sol]

great....this is good enough for me. It gives me something to start ... I was hopeing to develop/use some relationships so that might work out.

Now (edited) let me ask about relationships if I may!?

What is the difference between Auto-Enter Lookedup and Calculated value?

I do understand what the words mean but how does it translate in real-life use?

...or bettet yet..how do I simply use Auto-Insert when I type into one DB and have it replicate the (lets say SomeID) into second DB?

so If I have auto number in One.fp5 I would like it be Auto Inserted from One.fp5 into Two.fp5 BY relationship so the two ARE synched up for sure? I know there is a way arrond it by having both fields in both DBs to be Auto-Serial but that is not what I need.....what I nedd is your help

Thank you Anatoli!

[Unable]

This link may be useful to you - or not.

[Leb i Sol]

thanx Unable.....I guess I really didn't know what I was getting into with FM and CDML. Meaning....that it takes 70 lines of notepad-coding to "just" do one logical/simple function.....should have kept my mouth shut and never said I can program!

Thank you all

[Leb i Sol]

ok Unable.....I read through all those posts and I already feel tired without even trying to apply it to mu solution

I think their conversation was about Value List rather than my post "1 form -NEW --> 2 DBs " where I would like to insert data in to 2 DBs but have only one form constructed on the HTML page. Here is more detail:

------FROM:HTML-----------------------------------

CustomerName:[____________] --->into Customer.fp5

Favorite Quote:[_______________]-----> into Quotes.fp5

...

...

..

.

-----------------------------------------------

Customer and Quotes.fp5 are related and it is Crutial that CustomerName gets to be inserted 1st so it genereates CustomerID (auto-increment) ..which I intend to record also in Quotes.fp5 along with whatever is later entered in Favorite Quote:[_______________]

.....................................maybe anatoli had the fastes solution...2 page thing where the second page could have some hidden field (=Token=CustomerID that was just auto-created) and then inserted into 2nd DB?no?

...sorry bout my "brain-spill" on this post

thanx guys