Re: type Choice and data bases

You can't do this with the Choice field where you are indeed restricted to
manually adding to the list.

If you only wanted to display the companies then you could for instance use
FP 2003 and Data View webpart creation to grab the companies from the
database, but how then to allow the user to select them - see them, yes,
(use them in a web part connection, yes) select them, no.

I think we're therefore into (possibly heavy) coding rather than in normal
usage of the product.

If you want to investigate that further the subnewsgroup for programming
issues is microsoft.public.sharepoint.windowsservices.development

Engelbert



"M.G." <mgen72@xxxxxxxxxxxxxxxxx> wrote in message
news:%23Aa4ulCSGHA.2176@xxxxxxxxxxxxxxxxxxxxxxx
Hi. I'm a beginner in SharePoint.

I want to create a task list to enter the tasks we do for our customers.
One of the fields of this list is the customer name.

The type of this field must be Choice, so the user will choose the
customer by using a drop-down list.

I see that if the type is Choice I must enter manually the names of the
customers, but they can change, and there can be a lot.

So, this field must get the customers name from a data base (access or sql
server). How can I get this? I haven't seen how to get this in SharePoint.



Thanks, regards,

M.G.




.

Relevant Pages

  • I think im in over my head, can some help?
    ... to display calls to DB tables and get them to display and the ... i have a database that tracks ... requirements for customers and i have the page layout done and all the ... be some coding on the on_click method but frankly i dont really know ...
    (comp.lang.basic.visual.misc)
  • Re: I think im in over my head, can some help?
    ... to display calls to DB tables and get them to display and the ... i have a database that tracks ... requirements for customers and i have the page layout done and all the ... be some coding on the on_click method but frankly i dont really know ...
    (comp.lang.basic.visual.misc)
  • HELP! unwanted fields
    ... Randy Harris and Bob Quintal have tried to help me with my data base report ... Data base is of customers who book a car to pick them up on a certain date ... They would also book a car for thier return on a date in the future. ...
    (comp.databases.ms-access)
  • Re: Is there a way to rank alphabets?
    ... I actually has a data base of day sales records and among ... the fields I have names of customers. ... select cells A1..A3 ...
    (microsoft.public.excel.misc)
  • Sending emails from Access
    ... The data base is simple: ... (Customers: with Id, Name, etc and e-mail address). ... send a e-mail to each customer with a report showing his datas. ... SendObject function. ...
    (comp.databases.ms-access)