I want to recreate a system written in Access

But want to create the tables on the fly

And then create the dicts at the same time

Tables no issue

BUT

How do I create all the dictionaries via a procedure

Will make it easy to change over then

I will have all the details to create it with

Thx

Gerry

HI Gerry,

Dictionary columns are just records in the "DICT." table so create that when you create the data table and then build the records for each column and simply write them there.

You can use the DICT_EQUATES insert record as a guide to what the fields are in the column record if you're not familiar with them already.

Carl Pates

Ok thanks Carl

Will have a go

Never done it before

Gerry

View this thread on the Works forum...