Wedding Gown Loan

[why2208]

Hi i am currently working on a wedding gown loan database project.

I have already entered the information in the tables, my customers, wedding gowns, brands, designers and loan. but now i am facing problems when I'm creating a form. previously i have already created 2 forms and they are customer info form and designer info form. these two forms allow me to search for my customers and designers and also to input new entry for them too.

now while creating my wedding gown form, after creating the combo box and selecting the specific wedding gown, all the corresponding info pops out correctly. But in my wedding gown i only have the brand id while the brand id is linked to another table with the attached brand name. how do i import over the brand name so that after selecting the specific wedding gown. sorry if i have phrased my question wrongly.

i am unable to upload the database project as it exceeded the max allowable size. sorry for any inconvenience and if possible will anyone be kind enough to help me on this project? I'm doing my final year in acc but i took up this information system mod and i suck at it. ;(\



With Regards

[orange]

Did you start with a clear definition of your business?
Have you built a data model based on your business rules?
Have you tested the model with some test data scenarios?
It would be helpful to readers if you would post a jpg of your tables and relationships, and a brief description of your business.

Do a compact and repair on your database?
Make a copy of your database.
Remove anything confidential.
Place the copy in a zip file.
Attach the zip file to your post, and provide some instruction to readers of what, where to look.