Using FMP4.1

How do I make this happen?

I created two fmp DB's. db"A" contains forms/layouts called comments. db"B" contains the comments.

When in a field in db"A" I want to type in many codes that represent the comments in db "B" example:

I would type in

A03

A44

C24

up to 60 of these codes.

I would click a button that would replace the above codes (that are all in one field) with their related comments from db"B".

Can someone point me in the right direction?

Version: v4.x

Platform: Windows 95/98

CobaltSky appears to have been helping you with this but it doesn't look like you ever resolved it.

Find and Substitute

To anyone attempting to help with this, you might want to review this other post to save readdressing the same questions and issues.

Howdy. Finding someone better to help you than Ray CobaltSky is pretty unlikely, but here's my 2 cents...

Don't type the comment codes all in one field. Type them into individual fields (up to 60) and then just have a calc field concatenate them all together. The net result will be to have them all in one field formatted however you specify.

--ST

Thanks!!! I will try that?

OK now I have all the codes in one field but how do I find and retrive the corressponding files from the other db (db"B") and get them into db "A".

Ya I am realy new at this.

newbe,

From your post on the FM Cafe, it sounds like you did not turn on "related values only" for your valuelist.

Give that a try.

I am realy new at this.

I am having troubles finding the way to turn "related values only" on.

Do I look in DB"A" or DB"B" or in the relationship between the two.