Create Database

[Jegajothy]

I have an Access 2007 database which I am trying to create and I am trying to implement a Main Form -- sub Form link. The file has one table called tblMain and another table, tblListofBooks. I am trying to achieve from the Main table, when I enter a given date, on the sub forms to enter the books that were distributed for that date. But somehow looks I am not getting it. I was not able to upload my file, thus hope if I can see a sample file how this is implemented would be ideal.


thank u.
Jegajothy

[June7]

Just saying 'not getting it' doesn't give us much information.

Forms and subforms should be linked by primary and foreign key fields. Dates usually make poor key fields.

Review http://office.microsoft.com/en-us/ac...010098674.aspx

[orange]

Before getting into forms and subforms, do you have a good understanding of the data required for your application?
Have you identified the entities and their attributes? Have you identified the business rules? Have you set up relationships?
Do you have some test data?

Here's a tutorial that should help.
Good luck.