Jump to content

2 Web Forms/2 Databases: Communication?


This topic is 8342 days old. Please don't post here. Open a new topic instead.

Recommended Posts

The problems with running a script which is handled by a single-threaded engine in the multi-user environment of the web is fraught with problems and has been widely discussed on this forum. You should research this forum to gain some insight. I still stand by my claims regarding this matter.

Link to comment
Share on other sites

Hello, I'm fairly new to FMPro and the DB world in general--a "green", fresh-out-of-college individual with little experience but much to learn and do.

anywho. I have two FM Dbs. I display info from one DB onto a web form (this works great). However, I put a button on the web form which will launch another browser window, displaying the second web form.

In that web form, I want do display the record from the 2nd DB, WHERE the 2nd DB's primary key matches the 1st DB's primary key.

I've been doing some reading and am wondering:

should I pass the RecordID from the 1st DB to the 2nd form as a -Token?

Or should I run a script?

Any ideas? Examples? Bouts of laughter from the experienced ones who find this too easy? smile.gif" border="0

Link to comment
Share on other sites

In order to find a record in the second database, perform a find for the matching key -- assuming there is one.

One of the things that makes it challenging is that you have not stated what the relationship is between the two databases: are they related in some way? If they are related, then perform a find for the matching keys. If they aren't, then it's a bugger of a task.

Link to comment
Share on other sites

That's something the higher powers wanted.

A user submits a form, the record updates the "change" database. Then we access that data using another form. If we like the "change", we submit the form, creating a permanent record in the original database (or, rather, overwriting an older record with new info.)

Thus, they need to grab info. from both databases where the "category id" across both is the same....

And do it from the web via forms....

Link to comment
Share on other sites

  • 3 weeks later...

The RecordID's will not be the same in both databases. No, perform a find for an identifying field value. I don't see why you'd *have* to use Tokens for this, unless you want to carry the value across a few pages before using it.

Link to comment
Share on other sites

This topic is 8342 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.