hello, i have been using access for 3 weeks now and finally i feel like im getting somewhere but unfortunately im having a slight problem
as i have learned inserting sub reports into reports by merging Primary keys into the main table or junction table are very beneficial and the more tables there are the more ull be able to create sub reports and create filters right ?
so what i did was i created a table only setting a Date Field and the primary key with its autonumber, and set that date fields default value =date() so it always shows present day, and then linked it to the main junction table so i can never type the wrong date, and also for later on i can search by date, not only by customer name, but its not working, in the conjunction table its giving me blank, is it because it is set default value =date() ? or dates cant have foreign keys ?