I have a DBC which contains all the views I need for a Project Inquiry form (these are construction type projects). I set a path, depending on which company the Purchase Order people pick (meaning company as far as what part of the company the Purchase Order person is in). So, once this path is set, all data is taken from that path.

My problem is this: There are two main files that are in a different path (folder) than the majority of the files. How do I get the right table to be opened (everything is set to AutoOpenTables = .T.) for my parameterized view? What happens is the table in the main path keeps opening and it is the wrong table. I thought that when I set up my original view and pulled the table from the path Y:\WACORP\NC that it would look there, but this obviously means nothing.

My main path is set to Y:\WACORP and that is also where the PO_NC.DBC file is located containing my views. Two of the views need to open their base tables in Y:\WACORP\NC, but they are opened in Y:\WACORP instead, since there are files with the same exact name there.

I sent this as an email to Mark McCasland, but thought I should also place this on Universal Thread. I am sure someone may have experienced the same thing at one time or another.