* Dumbass attack; from the jargon file; a stupid act by someone who should know better, a mistake that only newbies should make.

I have a number of forms that act simmilar; they all are interfaces to tables of test results and the customer information input works the same.

There are a number of fields visible on the form Customer name, project name, attention, etc. which are read only - basicly for information of the user. There populated from a customer table, and each test has there own table. The user selects a file id from a pulldown list, and the approiate text blocks are updated. (via a thisform.refresh() in the interactivechange method of the pd-list)

Since everything was displayed nicely, and I could access the customer fields (and everything else) to OLE them over to Excel I thought everything was working.

Then with the latest table and associated form I created I needed a report (the first I've done, ever). All the report was some of the labdata, some numbers and a couple of text blocks, and the customer/fileid# so the techs could laze a copy off to take into the field for calibration of our machenery.

But the report dosent get the customerid; on further checking that field in this paticular tests table is empty. On closer examination it looks like the pulldown lists in all my forms dont place there contents into the testresults tables at all.

As I type this I realise something - the customer information dosent do change from record to record. My test set only consisted of 3 customer records, and only one record per each testresults table, so I jsut not noticed this. Also, I have no relations defined in my database. (you can laugh..... now)

I know what I have to do just need either point in the right dirrection or a slap upside the head.

- I can populate some textblocks from a refresh() of a text block, when the controlsource = rowsource and the type = 6(fields) every other seemingly logical possibilty either turns the pdl gray and dead, or the text is empty and once a selection is made it returns blank.

So how do I actulay make this work? You proably have to spell it out; it apperes I have no idea how to do it. The fschkin 65Hz 256 colour video must be sucking out all the clueons I have left.