I have 3 ASCII files of records:
1. Learner Data (one record per learner)
2. Learning Aim (zero to many records per learner)
3. SEF Data (zero to many records per learner)
They have a common link of Learner Number.
I need to now create one ASCII file of these records in a particular order and keep the field type and size accurately from the original 3 files. (Each of the files has a varied amount of field names, sizes and data types).
The order should be the first Learner Number record from Learner Data file as a single computer record (fixed length as already setup in original file, no field separators), use the character pair, carriage return followed by line feed as terminator THEN any related records for that Learner Number from Learning Aim file (again as single records with carriage retrun, line feed, etc.) THEN any related records for that Learner Number from SEF Data file. My vb skills are limited, I have no idea how to code this. I started off with raw data and amazed I have got this far (using ACCESS). Urgent piece of work to be uploaded to government office system tomorrow! HELP.