Gasman
Enthusiastic Amateur
- Local time
- Today, 01:40
- Joined
- Sep 21, 2011
- Messages
- 15,824
According to post #11 it is called LocationID ?, which to me would always be numeric?in sql view its
Code:SELECT Tmain.RiskID, Tmain.RiskCode, Tmain.riskTitle, Tmain.isActive, Tmain.RiskdueDate, Tmain.RiskDate, Tmain.location, Tmain.locationPricies, Tmain.risktype, Tmain.riskcolor, Tmain.reporter, Tmain.picafter, Tmain.picbefore FROM Tmain;
yes
short text
Even that completely different sql is still ID???