MEMO field question

[BAzZ]

If I have a memo field, which lists people's names, is there anyway I can extract, each persons name to fill in other fields. I'm designing a database as an application form, which has the main applicant, and "other people accompanying", this can have from 0 other people up to a coach load of extra people. I have set the memo field to be filled in with the other people accompanying. The "other people" have to sign the application, so I've set up another form with about 40 fields for their names, is there a way to extract the "other people" list, to populate the other form for the signatures.

 

[bradcccs]

You have a flaw in your design. A memo field is not where you should be storing this "extra" data.

I suggest creating a seperate table to store the "Extra People", with a link to the Primary applicant. Then you could structure your form with a subform for Extra People. This will enable you to query / report on the "Extras" as you see fit.

Table_Applicant:
AppID / AppName / etc etc

Table_Extra:
ExtraID / AppID (link field) / ExtraName / etc etc

You may need to research database design a little further.

HTH

Brad.

 

[BAzZ]

OK, I've restructured, I set up a new table, and a command button on the main form which opens the form to add more people. How do I go about, extracting those names to fill in a form for their signatures, like I was saying before, for one applicant there could from 0 to alot accompanying them.

 

[bradcccs]

If you were to create a subform in datasheet style linked on the ApplicantID, you would be able to enter the extras on the primary form.

How do I go about, extracting those names

Do you have a substantial amount of records currently in the old memo format?

If so, "extracting" the current data could prove to be quite a task, unless you have used some form of uniformity (ie: csv type format).

??

Brad.