Got a quick question that might turn out to be not so quick...I'm trying to create a report off of 2 tables, 1 of these tables is created automatically every week using a create table query, so it therefore has no relationship set up with the 2nd table because in order for the make table query to run it must delete the existing table and therefore the existing table can't have a relationship. So basically I'm kinda stuck...on one hand I can't have a relationship set up because it has to be deleted to run the make table query, and on the other hand I have to have a relationship set up to run the report. Basically I'm asking if there is any way to create and/or delete a relationship using code.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Creating Relationships in order to run a report
- Thread starter GoDawgs
- Start date
- Thread starter
- #2
Junior1544
Technical User
what was the answer?? let us all benefit from your work
--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.
--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.
- Thread starter
- #4
well the first time I tried to create the report I used a wizard, and that's when I got the error message saying I needed to have the tables linked...but when I created the report just in design view and then set the data source myself I could link the tables in the query to create the data source, so there was no problem after all...sorry, should've posted that the first time.
Junior1544
Technical User
Thanks. JHauge@jmjpc.net
Life is change. To deny change is to deny life.
JHauge@jmjpc.netLife is change. To deny change is to deny life.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question