Hi Everyone,
I am setting up some tables to store our customers info and they originally only had only a single video in their record that they could have received from us, so there was no need to store the videos in another table. Now we are adding several videos per month and I am setting up another table for them.
I am setting up a new database and want to do this right, but I am in need of some guidance.
I can relate their record to a video table, and in that table, store the records of all the videos they have purchased from us, but I need to make an export form for the marketing people and I am not sure how to 're-assemble' all the related videos into one record for export.
If they were all in one record, I am already capable of doing that, but the second, related table adds a level of complexity that is confusing me on how to move ahead with the export.
Anyone have an example of this already?
I appreciate any help.
Thanks,
Don
